Store to Database

 

This utility allows the user to store phone numbers in a database. This also allows the user to store phone numbers from Genesys sample files that were generated using the Do Not Store option. The database can then be used for unduplicating. ASCII or delimited files are the two types of files that can be used to store phone numbers.

 

  1. On the Utilities menu, click Store to Database.

 

 

A Store Phone Numbers dialog box opens.

 

  1. Click Browse to find the file containing the phone numbers that will be stored in the database.

 

  1. If the file is ASCII (American Standard Code for Information Interchange), such as a Genesys sample file (*.smp), the dialog box looks like this:

 

 

The sample file is open and a portion of the file can be viewed. By default, the first 10 digits are highlighted as the phone number, and the Phone Starting Position is populated. If this is not correct, use the LEFT and RIGHT ARROW keys to select the correct starting position. The Phone Starting Position will change automatically.

 

  1. If the file is delimited, the Store Phone Numbers dialog box looks like this:

 

 

The delimited file is open and a portion of the file can be viewed. The file will list the field names and values. By default, the program will look for the phone number in the first field.

 

If the phone number is not in the first field,  the phone number must be manually located. Type the phone number's field number in the Field Number box. Type the starting position for the phone number (where the exchange begins) in the Phone Starting Position box.

 

 

  1. Click Store to store the phone numbers in the database.

 

Once processing begins, replaces Help .

 

 

  1. To cease processing, click Stop Process to end the Store to Database process.

 

  1. If processing is stopped, a message confirms the cancellation.

 

 

  1. If processing continues, a message says how many records were read and how many were skipped.